MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Role = 960

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, City, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
187298 2012.81 0 0 299480 Photographs 13 Micrograph 13001 Ophthalmoscopie Clinique: Avec 40 Photographies Hors Texte           Author|Author|Artist 960   Louis de Wecker|Julien Masselon|Unknown 1832–1906|French, 1844–1917   de Wecker, Louis|Masselon, Julien|Unknown 16771   1832 |1844 1906 |1844 1870s–80s 1870 1881 Albumen silver prints 26067 19.1 x 11.4 cm (7 1/2 x 4 1/2 in.) Joyce F. Menschel Photography Library Fund, 2012                       Books 442   Metropolitan Museum of Art, New York, NY 1
216452 49.36.9 0 0 343883 Drawings and Prints 11 Book 97 Biblische Geschichten Deß Alten und Neuen Testaments / Historiae Biblicae Veteris et Novi Testamenti           Author|Author|Artist 960 Written by|Written by Joseph Sebastian Klauber|Johann Baptist Klauber|Johann Adam Stockmann German, ca. 1700–1768|German, 1712–ca. 1787|German   Klauber, Joseph Sebastian|Klauber, Johann Baptist|Stockmann, Johann Adam 20631 German|German|German 80 1700 |1712 1768 |1787 1748 1748 1748 Engraving 7208 9 1/16 x 13 3/8 x 1 9/16 in. (23 x 34 x 4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949   Augsburg 424                   Books 442   Metropolitan Museum of Art, New York, NY 1
219816 33.48 0 0 347341 Drawings and Prints 11 Book 97 Poëmes d'Amour           Author|Author|Artist 960 Music by|Written by Auguste Chapuis|Rodolphe Darzens|Adolphe-Léon Willette French, 1858–1933|French, Châlons-sur-Marne 1857–1926 Paris   Chapuis, Auguste|Darzens, Rodolphe|Willette, Adolphe-Léon 22853 French|French|French 103 1858 |1857 1933 |1926 1895 1895 1895 plates: Lithography 34558   Harris Brisbane Dick Fund, 1933   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
236508 44.41.3 0 0 364404 Drawings and Prints 11 Book 97 Monasticon Anglicanum, A History of the Abbies and Other Monasteries, Hospitals, Frieries, and Cathedral and Collegiate Churches, with their Dependencies, in England and Wales; also of all such Scotch, Irish and French Monasteries, as were in any Manner Connected with Religious Houses in England, Vol. III           Author|Author|Artist 960   Sir William Dugdale|Roger Dodsworth|Wenceslaus Hollar British, 1605–1686|British, 1585–1654|Bohemian, Prague 1607–1677 London   Dugdale, William Sir|Dodsworth, Roger|Hollar, Wenceslaus 32313 British|British|Bohemian 1572 1605 |1585 |1607 1605 |1654 |1677 1674 1674 1674 Illustrations: etching and engraving 29021 14 x 9 1/4 x 1 5/8 in. (35.5 x 23.5 x 4.2 cm) Harris Brisbane Dick Fund, 1944                       Books 442   Metropolitan Museum of Art, New York, NY 1
267258 32.35(176) 0 1 396299 Drawings and Prints 11 Print 731 The New Metamorphosis, Plate 6: The Story of Cupid and Psyche           Author|Author|Artist 960   Charles Gildon|Lucius Madaurensis Apuleius|William Hogarth British, ca. 1665–1724|M'Daourouch, Algeria ca. 124–after 170|British, London 1697–1764 London   Gildon, Charles|Apuleius, Lucius Madaurensis|Hogarth, William 39446 British|Algerian|British 3069 1660 |0120 |1697 1724 |0224 |1764 1724 1723 1724 Etching and engraving; second state of two 35451 sheet: 5 11/16 x 2 7/8 in. (14.4 x 7.3 cm) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
295619 33.77.4(1) 0 0 425181 Drawings and Prints 11 Print 731 Title Page, from Pygmalion, Scene Lyrique de Mr. J. J. Rousseau, Mise en Vers par Mr. Berquin. Le Text Gravé par Droüet. Paris 1775 in a blue paper folder with Idylle par Mr. Berquin         Pygmalion, Scene Lyrique de Mr. J. J. Rousseau, Mise en Vers par Mr. Berquin. Le Text Gravé par Droüet. Paris 1775 in a blue paper folder with Idylle par Mr. Berquin 279 Author|Author|Artist 960   Jean Jacques Rousseau|Arnaud Berquin|Droüet Swiss, Geneva 1712–1778 Ermenonville|French, 1749–1791|French, 18th century   Rousseau, Jean Jacques|Berquin, Arnaud|Droüet 42258 Swiss|French|French 3020 1712 |1749 |1760 1778 |1791 |1860 published in 1775 1775 1775 Etching and engraving 6712 Sheet: 9 1/8 × 6 1/16 in. (23.2 × 15.4 cm) Gift of Philip Hofer, 1933   Paris 27                   Prints 13   Metropolitan Museum of Art, New York, NY 1
441392 PL2693.H76 H74 1977 Quarto 1 0 736858 The Libraries 20   Hsi-hsiang chi, chinesische Farbholzschnitte von Min Chʻi-chi 1640           Author|Author|Artist 960   Edith Dittrich|Shifu Wang|Min Qiji Chinese, 1260-1316|Chinese, 1575 or 1580–?   Dittrich, Edith|Wang, Shifu|Min Qiji 56240   1260 |1575 1316 |1675 1977 1977 1977   87 pages, [21] leaves of plates : illustrations (some color), facsimiles ; Height: 16 9/16 in. (42 cm) Gift of Friends of the Thomas J. Watson Library   Köln 2560     Germany 16                 Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 129.235ms · Data license: CC0 · Data source: metmuseum/openaccess